package com.sky.mapper.admin;

import com.sky.dto.GoodsSalesDTO;
import com.sky.vo.DishOverViewVO;
import com.sky.vo.OrderDayAmountVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.time.LocalDate;
import java.util.List;

@Mapper
public interface ReportMapper {

    List<OrderDayAmountVo> turnoverStatistics(LocalDate begin,LocalDate end);

    List<OrderDayAmountVo> orderStatisitcs(LocalDate begin,LocalDate end);

    List<GoodsSalesDTO> dishTop10(LocalDate begin,LocalDate end);

    @Select("select count(1) from user where create_time > #{now}")
    Integer getNewUser(LocalDate now);

    DishOverViewVO dishStatusCount();

    DishOverViewVO setmealStatusCount();

    OrderDayAmountVo orderExportBaseData(LocalDate begin,LocalDate end);
}
